Release 10.1A: OpenEdge Reporting:
Query/Results for UNIX

Where option

The Where option enables you to build WHERE clauses to select record subsets. You can build WHERE clauses for any type of selection; that is, you can combine selection criteria using the AND or OR operator. For example, you can build WHERE clauses that:

Find all customers in Connecticut, New Hampshire, or Massachusetts that have credit limits greater than $1,000.

Each query form can be generated automatically for all fields in a file, or generated from a user-selected subset of the fields within a file.

When you select the Query module from the main menu, Results displays a list of forms that you can work with. Press MODE to toggle between descriptions, filenames, and programs. You can select forms from any of these lists. Once you select a form, for example, Customer information, the first record in that file appears, as shown in Figure 4–1.

Figure 4–1: Layout of the Query window

As shown in Figure 4–1, the Query window has several features. Note the following Query window characteristics:

The Query window displays record information, and the header at the top of the query form describes the set of records you can examine. In this case, it is the full set of customer records in the mysports database. (Similarly, when you use the Browse option, you see the full set of customer records.)
When you start the Query module or select a new form using the View option, you always begin working with a full set of forms.
When you use the Where or Query options to select a subset of records, you begin working with a subset of forms and the window header changes to Subset.
The Query window also shows horizontal menu options that let you work with other records in the active file. A message at the bottom of the window describes the function of the option that you have highlighted on the horizontal menu.

The following sections describe the menu and other Query options in more detail.